## Warning: package 'tidyverse' was built under R version 4.2.2

## Warning: package 'ggplot2' was built under R version 4.2.2

## Warning: package 'tibble' was built under R version 4.2.2

## Warning: package 'tidyr' was built under R version 4.2.2

## Warning: package 'readr' was built under R version 4.2.2

## Warning: package 'purrr' was built under R version 4.2.2

## Warning: package 'dplyr' was built under R version 4.2.2

## Warning: package 'stringr' was built under R version 4.2.2

## Warning: package 'forcats' was built under R version 4.2.2

## Warning: package 'lubridate' was built under R version 4.2.2

## ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
## ✔ dplyr     1.1.0     ✔ readr     2.1.4
## ✔ forcats   1.0.0     ✔ stringr   1.5.0
## ✔ ggplot2   3.4.1     ✔ tibble    3.1.8
## ✔ lubridate 1.9.2     ✔ tidyr     1.3.0
## ✔ purrr     1.0.1     
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag()    masks stats::lag()
## ℹ Use the ]8;;http://conflicted.r-lib.org/conflicted package]8;; to force all conflicts to become errors

## Warning: package 'shiny' was built under R version 4.2.3

## Warning: package 'kableExtra' was built under R version 4.2.3

## 
## Attaching package: 'kableExtra'
## 
## The following object is masked from 'package:dplyr':
## 
##     group_rows

Lights, camera, action!

Today, we’re going to take a deep dive into the world of HBO movies and TV shows. From the iconic dramas like The Sopranos and Game of Thrones to the latest releases, HBO has been providing quality content to its viewers for decades. But have you ever wondered how they make decisions about what shows to produce or which movies to acquire? That’s where the fascinating world of HBO data comes into play. By analyzing audience trends, ratings, and viewer demographics, HBO can make informed decisions about what to offer to its loyal fans. So sit back, grab some popcorn, and get ready to explore the exciting world of HBO data.

The data we’ve decided to work on is from kaggle, owned by Diego Enrique and here’s the link https://www.kaggle.com/datasets/dgoenrique/hbo-max-movies-and-tv-shows



Let us read our datas, shall we?

## Rows: 64,879
## Columns: 5
## $ person_id <int> 14701, 14702, 14703, 14704, 14705, 14706, 1367, 14716, 14707…
## $ id        <chr> "tm77588", "tm77588", "tm77588", "tm77588", "tm77588", "tm77…
## $ name      <chr> "Humphrey Bogart", "Ingrid Bergman", "Paul Henreid", "Claude…
## $ character <chr> "Rick Blaine", "Ilsa Lund", "Victor Laszlo", "Captain Louis …
## $ role      <chr> "ACTOR", "ACTOR", "ACTOR", "ACTOR", "ACTOR", "ACTOR", "ACTOR…

## Rows: 3,030
## Columns: 15
## $ id                   <chr> "tm77588", "tm155702", "tm83648", "tm3175", "ts22…
## $ title                <chr> "Casablanca", "The Wizard of Oz", "Citizen Kane",…
## $ type                 <chr> "MOVIE", "MOVIE", "MOVIE", "MOVIE", "SHOW", "MOVI…
## $ description          <chr> "In Casablanca, Morocco in December 1941, a cynic…
## $ release_year         <int> 1943, 1939, 1941, 1945, 1940, 1940, 1946, 1934, 1…
## $ age_certification    <chr> "PG", "G", "PG", "", "", "G", "", "", "", "PG-13"…
## $ runtime              <int> 102, 102, 119, 113, 8, 238, 114, 93, 111, 109, 12…
## $ genres               <chr> "['drama', 'romance', 'war']", "['fantasy', 'fami…
## $ production_countries <chr> "['US']", "['US']", "['US']", "['US']", "['US']",…
## $ seasons              <dbl> NA, NA, NA, NA, 16, NA, NA, NA, NA, NA, NA, NA, N…
## $ imdb_id              <chr> "tt0034583", "tt0032138", "tt0033467", "tt0037059…
## $ imdb_score           <dbl> 8.5, 8.1, 8.3, 7.5, 7.7, 8.2, 7.9, 7.9, 7.9, 8.3,…
## $ imdb_votes           <dbl> 577842, 406105, 446627, 25589, 859, 319463, 87289…
## $ tmdb_popularity      <dbl> 22.005, 56.631, 19.900, 8.311, 1.400, 27.535, 11.…
## $ tmdb_score           <dbl> 8.167, 7.583, 8.022, 7.000, 10.000, 8.000, 7.700,…



Whoops! let’s make it a little more readable

here’s our titles.csv

Sample table of credits data

person_id	id	name	character	role
14701	tm77588	Humphrey Bogart	Rick Blaine	ACTOR
14702	tm77588	Ingrid Bergman	Ilsa Lund	ACTOR
14703	tm77588	Paul Henreid	Victor Laszlo	ACTOR
14704	tm77588	Claude Rains	Captain Louis Renault	ACTOR
14705	tm77588	Conrad Veidt	Major Heinrich Strasser	ACTOR
14706	tm77588	Sydney Greenstreet	Signor Ferrari	ACTOR

And here’s our titles.csv

Sample table of titles data

id	title	type	description	release_year	age_certification	runtime	genres	production_countries	seasons	imdb_id	imdb_score	imdb_votes	tmdb_popularity	tmdb_score
tm77588	Casablanca	MOVIE	In Casablanca, Morocco in December 1941, a cynical American expatriate meets a former lover, with unforeseen complications.	1943	PG	102	[‘drama’, ‘romance’, ‘war’]	[‘US’]	NA	tt0034583	8.5	577842	22.005	8.167
tm155702	The Wizard of Oz	MOVIE	Young Dorothy finds herself in a magical world where she makes friends with a lion, a scarecrow and a tin man as they make their way along the yellow brick road to talk with the Wizard and ask for the things they miss most in their lives. The Wicked Witch of the West is the only thing that could stop them.	1939	G	102	[‘fantasy’, ‘family’]	[‘US’]	NA	tt0032138	8.1	406105	56.631	7.583
tm83648	Citizen Kane	MOVIE	Newspaper magnate, Charles Foster Kane is taken from his mother as a boy and made the ward of a rich industrialist. As a result, every well-meaning, tyrannical or self-destructive move he makes for the rest of his life appears in some way to be a reaction to that deeply wounding event.	1941	PG	119	[‘drama’]	[‘US’]	NA	tt0033467	8.3	446627	19.900	8.022
tm3175	Meet Me in St. Louis	MOVIE	In the year before the 1904 St. Louis World’s Fair, the four Smith daughters learn lessons of life and love, even as they prepare for a reluctant move to New York.	1945		113	[‘drama’, ‘family’, ‘romance’, ‘music’, ‘comedy’]	[‘US’]	NA	tt0037059	7.5	25589	8.311	7.000
ts225761	Tom and Jerry	SHOW	Tom and Jerry is an American animated franchise and series of comedy short films created in 1940 by William Hanna and Joseph Barbera. Best known for its 161 theatrical short films by Metro-Goldwyn-Mayer, the series centers on a friendship/rivalry (a love-hate relationship) between the title characters Tom, a cat, and Jerry, a mouse. Many shorts also feature several recurring characters.	1940		8	[‘animation’, ‘comedy’, ‘family’, ‘action’]	[‘US’]	16	tt6422744	7.7	859	1.400	10.000
tm156463	Gone with the Wind	MOVIE	The spoiled daughter of a Georgia plantation owner conducts a tumultuous romance with a cynical profiteer during the American Civil War and Reconstruction Era.	1940	G	238	[‘drama’, ‘romance’, ‘war’, ‘history’]	[‘US’]	NA	tt0031381	8.2	319463	27.535	8.000

Firstly let’s see how many movies and TV shows we are dealing with

##    type    n
## 1 MOVIE 2408
## 2  SHOW  622

Wow! that’s a lot more movies than shows! But let’s see it in a graph

And what’s the distribution of genres do we have from both?

## `summarise()` has grouped output by 'genres'. You can override using the
## `.groups` argument.

Looks like the type of genres are hard to read. Let’s flip our coordinates

## `summarise()` has grouped output by 'genres'. You can override using the
## `.groups` argument.

Here are the number of shows available in Netflix as a function of time¶

## `summarise()` has grouped output by 'release_year'. You can override using the
## `.groups` argument.

Now let’s see what are the top 10 most popular movies and show from imbd and tmdb

##                                                title  type release_year
## 1                           The Shawshank Redemption MOVIE         1994
## 2                                    Celebrity Habla MOVIE         2009
## 3                                  Emergency Contact MOVIE         2015
## 4                                    The Dark Knight MOVIE         2008
## 5      The Lord of the Rings: The Return of the King MOVIE         2003
## 6                Euphoria: Trouble Don't Last Always MOVIE         2020
## 7        Juan Luis Guerra 4.40: Entre Mar y Palmeras MOVIE         2021
## 8  The Lord of the Rings: The Fellowship of the Ring MOVIE         2001
## 9              The Lord of the Rings: The Two Towers MOVIE         2002
## 10                                 Celebrity Habla 2 MOVIE         2010
##                                      genres
## 1                                 ['drama']
## 2                         ['documentation']
## 3                                ['comedy']
## 4  ['drama', 'thriller', 'action', 'crime']
## 5            ['fantasy', 'action', 'drama']
## 6                                 ['drama']
## 7                                 ['music']
## 8            ['fantasy', 'action', 'drama']
## 9            ['action', 'fantasy', 'drama']
## 10                        ['documentation']

##                                                title  type release_year
## 1                           The Shawshank Redemption MOVIE         1994
## 2                                    Celebrity Habla MOVIE         2009
## 3                                  Emergency Contact MOVIE         2015
## 4                                    The Dark Knight MOVIE         2008
## 5      The Lord of the Rings: The Return of the King MOVIE         2003
## 6                Euphoria: Trouble Don't Last Always MOVIE         2020
## 7        Juan Luis Guerra 4.40: Entre Mar y Palmeras MOVIE         2021
## 8  The Lord of the Rings: The Fellowship of the Ring MOVIE         2001
## 9              The Lord of the Rings: The Two Towers MOVIE         2002
## 10                                 Celebrity Habla 2 MOVIE         2010
##                                      genres
## 1                                 ['drama']
## 2                         ['documentation']
## 3                                ['comedy']
## 4  ['drama', 'thriller', 'action', 'crime']
## 5            ['fantasy', 'action', 'drama']
## 6                                 ['drama']
## 7                                 ['music']
## 8            ['fantasy', 'action', 'drama']
## 9            ['action', 'fantasy', 'drama']
## 10                        ['documentation']

##                          title type release_year
## 1             Band of Brothers SHOW         2001
## 2                    Chernobyl SHOW         2019
## 3                     The Wire SHOW         2002
## 4            Eyes on the Prize SHOW         1987
## 5                 The Sopranos SHOW         1999
## 6              Game of Thrones SHOW         2011
## 7               Rick and Morty SHOW         2013
## 8                    Homegrown SHOW         2021
## 9               The Last of Us SHOW         2023
## 10 Batman: The Animated Series SHOW         1992
##                                                          genres
## 1                         ['drama', 'war', 'history', 'action']
## 2                              ['drama', 'thriller', 'history']
## 3                                ['drama', 'crime', 'thriller']
## 4                                  ['documentation', 'history']
## 5                                            ['drama', 'crime']
## 6            ['scifi', 'drama', 'action', 'romance', 'fantasy']
## 7                    ['animation', 'scifi', 'action', 'comedy']
## 8                                    ['documentation', 'drama']
## 9            ['drama', 'action', 'horror', 'scifi', 'thriller']
## 10 ['family', 'scifi', 'animation', 'action', 'crime', 'drama']

You can see there is a wide range of movies and tv shows, especially what year they were released. I wonder what the newest and oldest movies are?

##                     title  type release_year     genres
## 1 The Prince of Magicians MOVIE         1901 ['comedy']

##                            title  type release_year                      genres
## 1 Marc Maron: From Bleak to Dark MOVIE         2023 ['comedy', 'documentation']

##          title type release_year                                        genres
## 1 Looney Tunes SHOW         1929 ['comedy', 'family', 'thriller', 'animation']

##            title type release_year
## 1 The Last of Us SHOW         2023
##                                               genres
## 1 ['drama', 'action', 'horror', 'scifi', 'thriller']

I definitely have not seen either of those movies, but everyone should know last of us because of tiktok.

Now I am wondering what is the longest movie?

##                          title  type runtime release_year genres
## 1 An Impossible Balancing Feat MOVIE       1         1902     []

##                    title  type runtime release_year                genres
## 1 Scenes from a Marriage MOVIE     299         1974 ['drama', 'european']

##                title type runtime seasons release_year                  genres
## 1 Meet the Batwheels SHOW       2       1         2022 ['animation', 'action']

##           title type runtime seasons release_year
## 1 Sesame Street SHOW      51      53         1969
##                                                  genres
## 1 ['comedy', 'animation', 'family', 'fantasy', 'music']

Now lets look at the credits data.

##       role     n
## 1    ACTOR 62158
## 2 DIRECTOR  2721

Are any of these actors/directors in multiple projects? If so, who was in the most projects?

## Rows: 45,276
## Columns: 2
## $ name <chr> " Amanda Phillips", "'Auntie' Mackay", "'Little Man' Machan", "'W…
## $ n    <int> 1, 1, 3, 3, 3, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 1, 1, 1, 1, 1, 1, 1,…

##           name  n
## 1 Grey DeLisle 60

##    person_id        id         name
## 1      14142   ts21507 Grey DeLisle
## 2      14142   ts21601 Grey DeLisle
## 3      14142   ts20381 Grey DeLisle
## 4      14142   ts22480 Grey DeLisle
## 5      14142    ts5042 Grey DeLisle
## 6      14142   tm94209 Grey DeLisle
## 7      14142   tm93784 Grey DeLisle
## 8      14142   tm58727 Grey DeLisle
## 9      14142  tm656353 Grey DeLisle
## 10     14142   tm43061 Grey DeLisle
## 11     14142   tm23583 Grey DeLisle
## 12     14142  tm140798 Grey DeLisle
## 13     14142   ts20574 Grey DeLisle
## 14     14142  tm167763 Grey DeLisle
## 15     14142   tm62126 Grey DeLisle
## 16     14142   tm30342 Grey DeLisle
## 17     14142  tm167388 Grey DeLisle
## 18     14142   tm65596 Grey DeLisle
## 19     14142  tm160240 Grey DeLisle
## 20     14142  tm160231 Grey DeLisle
## 21     14142  tm151689 Grey DeLisle
## 22     14142  tm179476 Grey DeLisle
## 23     14142  tm177932 Grey DeLisle
## 24     14142    ts3139 Grey DeLisle
## 25     14142  tm159051 Grey DeLisle
## 26     14142  tm171655 Grey DeLisle
## 27     14142   tm63619 Grey DeLisle
## 28     14142  tm152510 Grey DeLisle
## 29     14142  tm152501 Grey DeLisle
## 30     14142   ts37956 Grey DeLisle
## 31     14142  tm195247 Grey DeLisle
## 32     14142  tm244555 Grey DeLisle
## 33     14142  tm238389 Grey DeLisle
## 34     14142  tm193859 Grey DeLisle
## 35     14142  tm244564 Grey DeLisle
## 36     14142  tm219341 Grey DeLisle
## 37     14142  tm214711 Grey DeLisle
## 38     14142  tm244119 Grey DeLisle
## 39     14142  tm244479 Grey DeLisle
## 40     14142  tm138025 Grey DeLisle
## 41     14142  tm365731 Grey DeLisle
## 42     14142  tm422417 Grey DeLisle
## 43     14142  tm301058 Grey DeLisle
## 44     14142  tm372838 Grey DeLisle
## 45     14142  tm361837 Grey DeLisle
## 46     14142  tm326858 Grey DeLisle
## 47     14142  tm414009 Grey DeLisle
## 48     14142  tm405461 Grey DeLisle
## 49     14142  tm317933 Grey DeLisle
## 50     14142  tm423754 Grey DeLisle
## 51     14142  tm820756 Grey DeLisle
## 52     14142   ts89867 Grey DeLisle
## 53     14142  tm894108 Grey DeLisle
## 54     14142  tm883958 Grey DeLisle
## 55     14142 tm1248448 Grey DeLisle
## 56     14142 tm1028015 Grey DeLisle
## 57     14142 tm1065433 Grey DeLisle
## 58     14142  tm930306 Grey DeLisle
## 59     14142 tm1171238 Grey DeLisle
## 60     14142  tm987899 Grey DeLisle
##                                                                           character
## 1                                                              Daphne Blake (voice)
## 2                                                        The High Priestess (voice)
## 3                                                              Daphne Blake (voice)
## 4                                                                     Mandy (voice)
## 5                                                  Frances 'Frankie' Foster (voice)
## 6                                                                    Daphne (voice)
## 7                                                              Daphne Blake (voice)
## 8                                             Daphne / Cat Witch / Honeybee (voice)
## 9  Frankie Foster / Tiny Friend / Little Boy Voice / Lady (voice) (as Grey DeLisle)
## 10                                        Crazy Old Cat Lady/Gramma Stuffum (voice)
## 11                                                                   Daphne (voice)
## 12                                                                   Daphne (voice)
## 13                                                                                 
## 14                                                           Barbara Gordon (voice)
## 15                                             Anchor Carla / Female Mutant (voice)
## 16                                                        Lois Lane / Queen (voice)
## 17                                       Ree'Yu / Ardakian Trawl / Boodikka (voice)
## 18                                                         Young Manchester (voice)
## 19                                                             Daphne Blake (voice)
## 20                                                             Daphne Blake (voice)
## 21                                            Grandmother (voice) (as Grey Griffin)
## 22                    Nora Allen / Young Barry Allen / Martha Wayne / Joker (voice)
## 23                                                             Anchor Carla (voice)
## 24                                                Margaret Sorrow / Magpie  (voice)
## 25                       Wonder Woman / Superbaby (voice) (as Grey DeLisle Griffin)
## 26                                                             Daphne Blake (voice)
## 27                                                             Daphne Blake (voice)
## 28                                                             Daphne Blake (voice)
## 29                                                             Daphne Blake (voice)
## 30                                                             Daphne Blake (voice)
## 31                                                          Tina / Platinum (voice)
## 32                                                             Daphne Blake (voice)
## 33                                                             Wonder Woman (voice)
## 34                                                                 Samantha (voice)
## 35                                                             Wonder Woman (voice)
## 36                                                 Wonder Woman / Lois Lane (voice)
## 37                                                             Daphne Blake (voice)
## 38                                                             Daphne Blake (voice)
## 39                                                             Wonder Woman (voice)
## 40                                                             Daphne Blake (voice)
## 41                                Sister Leslie / Jason / Additional Voices (voice)
## 42                                                             Daphne Blake (voice)
## 43                                                             Daphne Blake (voice)
## 44                        Wonder Woman / Diana Prince (voice) and Lois Lane (voice)
## 45                                              Daphne Blake / Black Canary (voice)
## 46                                                             Daphne Blake (voice)
## 47           Diana Prince / Wonder Woman (voice) / Lois Lane (voice) / Ring (voice)
## 48                                                         Wonder Woman / Lois Lane
## 49                                                  Wonder Woman / Platinum (voice)
## 50                                                             Wonder Woman (voice)
## 51                                                               Mrs. Claus (Voice)
## 52                                                             Daphne Blake (voice)
## 53                                                        Additional Voices (voice)
## 54                                         Wonder Woman (voice) / Lois Lane (voice)
## 55                                     Daphne / Daisy / Musketeer 1 / Olive (voice)
## 56                                   Beelzebub / Little Della / Little Jack (voice)
## 57                                         Daphne Blake / Frau Glockenspiel (voice)
## 58                                                                 Lady Eve (voice)
## 59                                              Diana Prince / Wonder Woman (voice)
## 60                                                             Daphne Blake (voice)
##     role
## 1  ACTOR
## 2  ACTOR
## 3  ACTOR
## 4  ACTOR
## 5  ACTOR
## 6  ACTOR
## 7  ACTOR
## 8  ACTOR
## 9  ACTOR
## 10 ACTOR
## 11 ACTOR
## 12 ACTOR
## 13 ACTOR
## 14 ACTOR
## 15 ACTOR
## 16 ACTOR
## 17 ACTOR
## 18 ACTOR
## 19 ACTOR
## 20 ACTOR
## 21 ACTOR
## 22 ACTOR
## 23 ACTOR
## 24 ACTOR
## 25 ACTOR
## 26 ACTOR
## 27 ACTOR
## 28 ACTOR
## 29 ACTOR
## 30 ACTOR
## 31 ACTOR
## 32 ACTOR
## 33 ACTOR
## 34 ACTOR
## 35 ACTOR
## 36 ACTOR
## 37 ACTOR
## 38 ACTOR
## 39 ACTOR
## 40 ACTOR
## 41 ACTOR
## 42 ACTOR
## 43 ACTOR
## 44 ACTOR
## 45 ACTOR
## 46 ACTOR
## 47 ACTOR
## 48 ACTOR
## 49 ACTOR
## 50 ACTOR
## 51 ACTOR
## 52 ACTOR
## 53 ACTOR
## 54 ACTOR
## 55 ACTOR
## 56 ACTOR
## 57 ACTOR
## 58 ACTOR
## 59 ACTOR
## 60 ACTOR

Including Plots

You can also embed plots, for example:

Note that the echo = FALSE parameter was added to the code chunk to prevent printing of the R code that generated the plot.